
/usr/bin/sqoop import  \
--connect jdbc:mysql://192.168.88.80:3306/scrm \
--username root \
--password 123456 \
--query "select * from customer where 1=1 and  \$CONDITIONS" \
--hcatalog-database edu_ods \
--hcatalog-table ods_customer \
-m 1

/usr/bin/sqoop import  \
--connect jdbc:mysql://192.168.88.80:3306/scrm \
--username root \
--password 123456 \
--query "select * from customer_appeal where 1=1 and  \$CONDITIONS" \
--hcatalog-database edu_ods \
--hcatalog-table ods_customer_appeal \
-m 1



/usr/bin/sqoop import  \
--connect jdbc:mysql://192.168.88.80:3306/scrm \
--username root \
--password 123456 \
--query "select * from customer_clue where 1=1 and  \$CONDITIONS" \
--hcatalog-database edu_ods \
--hcatalog-table ods_customer_clue \
-m 1



/usr/bin/sqoop import  \
--connect jdbc:mysql://192.168.88.80:3306/scrm \
--username root \
--password 123456 \
--query "select * from customer_relationship where 1=1 and  \$CONDITIONS" \
--hcatalog-database edu_ods \
--hcatalog-table ods_customer_relationship \
-m 1


/usr/bin/sqoop import  \
--connect jdbc:mysql://192.168.88.80:3306/scrm \
--username root \
--password 123456 \
--query "select * from scrm_department where 1=1 and  \$CONDITIONS" \
--hcatalog-database edu_ods \
--hcatalog-table ods_department \
-m 1



/usr/bin/sqoop import  \
--connect jdbc:mysql://192.168.88.80:3306/scrm \
--username root \
--password 123456 \
--query "select * from employee where 1=1 and  \$CONDITIONS" \
--hcatalog-database edu_ods \
--hcatalog-table ods_employee \
-m 1



/usr/bin/sqoop import  \
--connect jdbc:mysql://192.168.88.80:3306/scrm \
--username root \
--password 123456 \
--query "select * from itcast_clazz where 1=1 and  \$CONDITIONS" \
--hcatalog-database edu_ods \
--hcatalog-table ods_itcast_clazz \
-m 1

/usr/bin/sqoop import  \
--connect jdbc:mysql://192.168.88.80:3306/scrm \
--username root \
--password 123456 \
--query "select * from itcast_school where 1=1 and  \$CONDITIONS" \
--hcatalog-database edu_ods \
--hcatalog-table ods_itcast_school \
-m 1


/usr/bin/sqoop import  \
--connect jdbc:mysql://192.168.88.80:3306/scrm \
--username root \
--password 123456 \
--query "select * from itcast_subject where 1=1 and  \$CONDITIONS" \
--hcatalog-database edu_ods \
--hcatalog-table ods_itcast_subject \
-m 1

